CREATE TABLE ProfileType(
	profileTypeID int IDENTITY,
	description varchar(50) NOT NULL,
	PRIMARY KEY (profileTypeID)
)

CREATE TABLE [User](
	userID int IDENTITY,
	username varchar(50) NOT NULL,
	password varchar(50) NOT NULL,
	name varchar(50) NOT NULL,
	email varchar(50) NOT NULL,
	birthdate date NOT NULL,
	residence varchar(100) NOT NULL,
	zipcode varchar(50) NOT NULL,
	city varchar(50) NOT NULL,
	contact varchar(50) NOT NULL,
	guid varchar(50),
	profileTypeID int NOT NULL,
	living_alone char(1),
	status char(1) NOT NULL,
	PRIMARY KEY (userID),
	FOREIGN KEY (profileTypeID) REFERENCES [ProfileType] (profileTypeID)
)



CREATE TABLE ParentescType(
	parentescID int IDENTITY,
	description varchar(50) NOT NULL,
	PRIMARY KEY (parentescID)
)

CREATE TABLE Relationship(
	relID int IDENTITY,
	elderlyID int NOT NULL,
	userID int NOT NULL,
	parentescID int NOT NULL,
	PRIMARY KEY (relID),
	FOREIGN KEY (userID) REFERENCES [User] (userID),
	FOREIGN KEY (parentescID) REFERENCES [ParentescType] (parentescID) 
)

